package com.sec.etech.org.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sec.etech.org.model.OrgGroupSyncHrs;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface OrgGroupSyncHrsMapper extends BaseMapper<OrgGroupSyncHrs> {
    @Select("SELECT * FROM org_group_sync_hrs a WHERE NOT EXISTS (SELECT * FROM org_group b WHERE a.id_=b.code_)")
    List<OrgGroupSyncHrs> getOrgGroupSyncHrsInsertList();

    @Select("SELECT * FROM org_group_sync_hrs a WHERE EXISTS (SELECT * FROM org_group b WHERE a.id_=b.code_)")
    List<OrgGroupSyncHrs> getOrgGroupSyncHrsUpdateList();
}

